package com.duowei.diandan.db.entry;

import android.arch.persistence.room.Entity;
import android.arch.persistence.room.PrimaryKey;

/**
 * 单品类别
 */
@SuppressWarnings("ALL")
@Entity
public class Dmjyxmsslb {
    @PrimaryKey(autoGenerate = true)
    private long id;

    /** 类别编码 */
    private String lbbm;
    /** 类别名称 */
    private String lbmc;
    private String py;
    private String flbbm;
    private String lblx;
    /** 是否显示(1不显示) */
    private String sfxs;
    /** 是否停用 */
    private String sfty;
    /** 排序 */
    private Float xl;

    public Dmjyxmsslb() {
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getLbbm() {
        return lbbm;
    }

    public void setLbbm(String lbbm) {
        this.lbbm = lbbm;
    }

    public String getLbmc() {
        return lbmc;
    }

    public void setLbmc(String lbmc) {
        this.lbmc = lbmc;
    }

    public String getPy() {
        return py;
    }

    public void setPy(String py) {
        this.py = py;
    }

    public String getFlbbm() {
        return flbbm;
    }

    public void setFlbbm(String flbbm) {
        this.flbbm = flbbm;
    }

    public String getLblx() {
        return lblx;
    }

    public void setLblx(String lblx) {
        this.lblx = lblx;
    }

    public String getSfxs() {
        return sfxs;
    }

    public void setSfxs(String sfxs) {
        this.sfxs = sfxs;
    }

    public String getSfty() {
        return sfty;
    }

    public void setSfty(String sfty) {
        this.sfty = sfty;
    }

    public Float getXl() {
        return xl;
    }

    public void setXl(Float xl) {
        this.xl = xl;
    }

    public static String querySql() {
        return "SELECT lbbm, lbmc, py, flbbm, lblx, sfxs, sfty, xl FROM DMJYXMSSLB " +
                "WHERE sfty != '1' AND lbbm != 'RICH' ORDER BY xl|";
    }
}
